﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;

namespace Jzy.Model.CRM
{
    public partial class SiteAccountInfo
    {
        public const string TABLE_NAME = "SiteAccount";
        public const string INSERT_SQL = "insert into SiteAccount ( [ID], [Name], [Url], [LoginName], [Password], [InputTime], [Remark], [IsPublic], [CreatorID], [CreatorName], [IsDelete]) values ( @ID, @Name, @Url, @LoginName, @Password, @InputTime, @Remark, @IsPublic, @CreatorID, @CreatorName, @IsDelete)";
        public const string UPDATE_SQL = "update SiteAccount set  [ID] = @ID, [Name] = @Name, [Url] = @Url, [LoginName] = @LoginName, [Password] = @Password, [InputTime] = @InputTime, [Remark] = @Remark, [IsPublic] = @IsPublic, [CreatorID] = @CreatorID, [CreatorName] = @CreatorName, [IsDelete] = @IsDelete where ID = @ID";
        /// <summary>
        /// PK
        /// </summary>
        public Int32 ID
        {
            get;
            set;
        }
        /// <summary>
        /// 网站名称
        /// </summary>
        public String Name
        {
            get;
            set;
        }
        /// <summary>
        /// 网站地址
        /// </summary>
        public String Url
        {
            get;
            set;
        }
        /// <summary>
        /// 登录名
        /// </summary>
        public String LoginName
        {
            get;
            set;
        }
        /// <summary>
        /// 密码
        /// </summary>
        public String Password
        {
            get;
            set;
        }
        /// <summary>
        /// 录入时间
        /// </summary>
        public DateTime InputTime
        {
            get;
            set;
        }
        /// <summary>
        /// 备注
        /// </summary>
        public String Remark
        {
            get;
            set;
        }
        /// <summary>
        /// 是否公开
        /// </summary>
        public Boolean IsPublic
        {
            get;
            set;
        }
        /// <summary>
        /// 登记人ID
        /// </summary>
        public Int32 CreatorID
        {
            get;
            set;
        }
        /// <summary>
        /// 登记人姓名
        /// </summary>
        public String CreatorName
        {
            get;
            set;
        }
        /// <summary>
        /// 是否逻辑删除
        /// </summary>
        public Boolean IsDelete
        {
            get;
            set;
        }
    }

}
